CREATE TABLE [dbo].[Name_Demo]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__Name_Demo_te__ID__71E7C201] DEFAULT (''),
[Spouse] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__Name_Demo__Spous__72DBE63A] DEFAULT (''),
[School_Attended] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__Name_Demo__Schoo__73D00A73] DEFAULT (''),
[Sponsor] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__Name_Demo__Spons__74C42EAC] DEFAULT (''),
[Mobile_Phone] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__Name_Demo__Mobil__75B852E5] DEFAULT (''),
[Date_Certified] [datetime] NULL,
[Staff_Size] [float] NOT NULL CONSTRAINT [DF__Name_Demo__Staff__76AC771E] DEFAULT ((0)),
[Annual_Revenue] [float] NOT NULL CONSTRAINT [DF__Name_Demo__Annua__77A09B57] DEFAULT ((0)),
[Activity_Fee] [money] NOT NULL CONSTRAINT [DF__Name_Demo__Activ__7894BF90] DEFAULT ((0)),
[System_Type] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__Name_Demo__Syste__7988E3C9] DEFAULT (''),
[Board] [bit] NOT NULL CONSTRAINT [DF__Name_Demo__Board__7A7D0802] DEFAULT ((0)),
[Newsletter] [bit] NOT NULL CONSTRAINT [DF__Name_Demo__Newsl__7B712C3B] DEFAULT ((0)),
[Key_Contact] [bit] NOT NULL CONSTRAINT [DF__Name_Demo__Key_C__7C655074] DEFAULT ((0)),
[Legislative] [bit] NOT NULL CONSTRAINT [DF__Name_Demo__Legis__7D5974AD] DEFAULT ((0)),
[Exhibitor] [bit] NOT NULL CONSTRAINT [DF__Name_Demo__Exhib__7E4D98E6] DEFAULT ((0)),
[Advertiser] [bit] NOT NULL CONSTRAINT [DF__Name_Demo__Adver__7F41BD1F] DEFAULT ((0)),
[Interest_Codes] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[List_Codes] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Name_Demo] ADD CONSTRAINT [PK_Name_Demo] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Name_Demo] TO [IMIS]
GRANT SELECT ON  [dbo].[Name_Demo] TO [IMIS]
GRANT INSERT ON  [dbo].[Name_Demo] TO [IMIS]
GRANT DELETE ON  [dbo].[Name_Demo] TO [IMIS]
GRANT UPDATE ON  [dbo].[Name_Demo] TO [IMIS]
GO